package com.mall.db.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mall.db.domain.Comments;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 评论管理表 Mapper 接口
 * </p>
 *
 * @author HQJ
 * @since 2021-09-22
 */

public interface CommentsDao extends BaseMapper<Comments> {
    @Select("select u.name userId,c.id id,g.name goodIds,c.score ,c.content ,c.photo ,c.create_time createTime from  t_user u,t_comments c,t_goods g where u.receipt_id=c.user_id and c.goods_id=g.id")
    List<Comments> find(Comments com);
}
